package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CoverageExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CoverageExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCorpCodeIsNull() {
            addCriterion("CORP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNotNull() {
            addCriterion("CORP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeEqualTo(String value) {
            addCriterion("CORP_CODE =", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotEqualTo(String value) {
            addCriterion("CORP_CODE <>", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThan(String value) {
            addCriterion("CORP_CODE >", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CORP_CODE >=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThan(String value) {
            addCriterion("CORP_CODE <", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThanOrEqualTo(String value) {
            addCriterion("CORP_CODE <=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLike(String value) {
            addCriterion("CORP_CODE like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotLike(String value) {
            addCriterion("CORP_CODE not like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIn(List<String> values) {
            addCriterion("CORP_CODE in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotIn(List<String> values) {
            addCriterion("CORP_CODE not in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeBetween(String value1, String value2) {
            addCriterion("CORP_CODE between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotBetween(String value1, String value2) {
            addCriterion("CORP_CODE not between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIsNull() {
            addCriterion("PLAN_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIsNotNull() {
            addCriterion("PLAN_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPlanCodeEqualTo(String value) {
            addCriterion("PLAN_CODE =", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotEqualTo(String value) {
            addCriterion("PLAN_CODE <>", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeGreaterThan(String value) {
            addCriterion("PLAN_CODE >", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PLAN_CODE >=", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLessThan(String value) {
            addCriterion("PLAN_CODE <", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLessThanOrEqualTo(String value) {
            addCriterion("PLAN_CODE <=", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLike(String value) {
            addCriterion("PLAN_CODE like", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotLike(String value) {
            addCriterion("PLAN_CODE not like", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIn(List<String> values) {
            addCriterion("PLAN_CODE in", values, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotIn(List<String> values) {
            addCriterion("PLAN_CODE not in", values, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeBetween(String value1, String value2) {
            addCriterion("PLAN_CODE between", value1, value2, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotBetween(String value1, String value2) {
            addCriterion("PLAN_CODE not between", value1, value2, "planCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeIsNull() {
            addCriterion("COVERAGE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeIsNotNull() {
            addCriterion("COVERAGE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeEqualTo(String value) {
            addCriterion("COVERAGE_CODE =", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeNotEqualTo(String value) {
            addCriterion("COVERAGE_CODE <>", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeGreaterThan(String value) {
            addCriterion("COVERAGE_CODE >", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeGreaterThanOrEqualTo(String value) {
            addCriterion("COVERAGE_CODE >=", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeLessThan(String value) {
            addCriterion("COVERAGE_CODE <", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeLessThanOrEqualTo(String value) {
            addCriterion("COVERAGE_CODE <=", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeLike(String value) {
            addCriterion("COVERAGE_CODE like", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeNotLike(String value) {
            addCriterion("COVERAGE_CODE not like", value, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeIn(List<String> values) {
            addCriterion("COVERAGE_CODE in", values, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeNotIn(List<String> values) {
            addCriterion("COVERAGE_CODE not in", values, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeBetween(String value1, String value2) {
            addCriterion("COVERAGE_CODE between", value1, value2, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andCoverageCodeNotBetween(String value1, String value2) {
            addCriterion("COVERAGE_CODE not between", value1, value2, "coverageCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNull() {
            addCriterion("USER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNotNull() {
            addCriterion("USER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUserCodeEqualTo(String value) {
            addCriterion("USER_CODE =", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotEqualTo(String value) {
            addCriterion("USER_CODE <>", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThan(String value) {
            addCriterion("USER_CODE >", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("USER_CODE >=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThan(String value) {
            addCriterion("USER_CODE <", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThanOrEqualTo(String value) {
            addCriterion("USER_CODE <=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLike(String value) {
            addCriterion("USER_CODE like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotLike(String value) {
            addCriterion("USER_CODE not like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIn(List<String> values) {
            addCriterion("USER_CODE in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotIn(List<String> values) {
            addCriterion("USER_CODE not in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeBetween(String value1, String value2) {
            addCriterion("USER_CODE between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotBetween(String value1, String value2) {
            addCriterion("USER_CODE not between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNull() {
            addCriterion("LASTEDIT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNotNull() {
            addCriterion("LASTEDIT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE =", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <>", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThan(Date value) {
            addCriterion("LASTEDIT_DATE >", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE >=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThan(Date value) {
            addCriterion("LASTEDIT_DATE <", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE not in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE not between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNull() {
            addCriterion("ACTIVE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNotNull() {
            addCriterion("ACTIVE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagEqualTo(String value) {
            addCriterion("ACTIVE_FLAG =", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <>", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThan(String value) {
            addCriterion("ACTIVE_FLAG >", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG >=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThan(String value) {
            addCriterion("ACTIVE_FLAG <", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLike(String value) {
            addCriterion("ACTIVE_FLAG like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotLike(String value) {
            addCriterion("ACTIVE_FLAG not like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIn(List<String> values) {
            addCriterion("ACTIVE_FLAG in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotIn(List<String> values) {
            addCriterion("ACTIVE_FLAG not in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG not between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andLoaDescIsNull() {
            addCriterion("LOA_DESC is null");
            return (Criteria) this;
        }

        public Criteria andLoaDescIsNotNull() {
            addCriterion("LOA_DESC is not null");
            return (Criteria) this;
        }

        public Criteria andLoaDescEqualTo(Object value) {
            addCriterion("LOA_DESC =", value, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescNotEqualTo(Object value) {
            addCriterion("LOA_DESC <>", value, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescGreaterThan(Object value) {
            addCriterion("LOA_DESC >", value, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescGreaterThanOrEqualTo(Object value) {
            addCriterion("LOA_DESC >=", value, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescLessThan(Object value) {
            addCriterion("LOA_DESC <", value, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescLessThanOrEqualTo(Object value) {
            addCriterion("LOA_DESC <=", value, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescIn(List<Object> values) {
            addCriterion("LOA_DESC in", values, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescNotIn(List<Object> values) {
            addCriterion("LOA_DESC not in", values, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescBetween(Object value1, Object value2) {
            addCriterion("LOA_DESC between", value1, value2, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andLoaDescNotBetween(Object value1, Object value2) {
            addCriterion("LOA_DESC not between", value1, value2, "loaDesc");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeIsNull() {
            addCriterion("SUB_COVERAGE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeIsNotNull() {
            addCriterion("SUB_COVERAGE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeEqualTo(String value) {
            addCriterion("SUB_COVERAGE_CODE =", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeNotEqualTo(String value) {
            addCriterion("SUB_COVERAGE_CODE <>", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeGreaterThan(String value) {
            addCriterion("SUB_COVERAGE_CODE >", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_COVERAGE_CODE >=", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeLessThan(String value) {
            addCriterion("SUB_COVERAGE_CODE <", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeLessThanOrEqualTo(String value) {
            addCriterion("SUB_COVERAGE_CODE <=", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeLike(String value) {
            addCriterion("SUB_COVERAGE_CODE like", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeNotLike(String value) {
            addCriterion("SUB_COVERAGE_CODE not like", value, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeIn(List<String> values) {
            addCriterion("SUB_COVERAGE_CODE in", values, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeNotIn(List<String> values) {
            addCriterion("SUB_COVERAGE_CODE not in", values, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeBetween(String value1, String value2) {
            addCriterion("SUB_COVERAGE_CODE between", value1, value2, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andSubCoverageCodeNotBetween(String value1, String value2) {
            addCriterion("SUB_COVERAGE_CODE not between", value1, value2, "subCoverageCode");
            return (Criteria) this;
        }

        public Criteria andEnglishDescIsNull() {
            addCriterion("ENGLISH_DESC is null");
            return (Criteria) this;
        }

        public Criteria andEnglishDescIsNotNull() {
            addCriterion("ENGLISH_DESC is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishDescEqualTo(String value) {
            addCriterion("ENGLISH_DESC =", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescNotEqualTo(String value) {
            addCriterion("ENGLISH_DESC <>", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescGreaterThan(String value) {
            addCriterion("ENGLISH_DESC >", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescGreaterThanOrEqualTo(String value) {
            addCriterion("ENGLISH_DESC >=", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescLessThan(String value) {
            addCriterion("ENGLISH_DESC <", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescLessThanOrEqualTo(String value) {
            addCriterion("ENGLISH_DESC <=", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescLike(String value) {
            addCriterion("ENGLISH_DESC like", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescNotLike(String value) {
            addCriterion("ENGLISH_DESC not like", value, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescIn(List<String> values) {
            addCriterion("ENGLISH_DESC in", values, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescNotIn(List<String> values) {
            addCriterion("ENGLISH_DESC not in", values, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescBetween(String value1, String value2) {
            addCriterion("ENGLISH_DESC between", value1, value2, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andEnglishDescNotBetween(String value1, String value2) {
            addCriterion("ENGLISH_DESC not between", value1, value2, "englishDesc");
            return (Criteria) this;
        }

        public Criteria andReserveAmtIsNull() {
            addCriterion("RESERVE_AMT is null");
            return (Criteria) this;
        }

        public Criteria andReserveAmtIsNotNull() {
            addCriterion("RESERVE_AMT is not null");
            return (Criteria) this;
        }

        public Criteria andReserveAmtEqualTo(BigDecimal value) {
            addCriterion("RESERVE_AMT =", value, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtNotEqualTo(BigDecimal value) {
            addCriterion("RESERVE_AMT <>", value, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtGreaterThan(BigDecimal value) {
            addCriterion("RESERVE_AMT >", value, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RESERVE_AMT >=", value, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtLessThan(BigDecimal value) {
            addCriterion("RESERVE_AMT <", value, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RESERVE_AMT <=", value, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtIn(List<BigDecimal> values) {
            addCriterion("RESERVE_AMT in", values, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtNotIn(List<BigDecimal> values) {
            addCriterion("RESERVE_AMT not in", values, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RESERVE_AMT between", value1, value2, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andReserveAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RESERVE_AMT not between", value1, value2, "reserveAmt");
            return (Criteria) this;
        }

        public Criteria andPrevalidityIsNull() {
            addCriterion("PREVALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andPrevalidityIsNotNull() {
            addCriterion("PREVALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andPrevalidityEqualTo(Short value) {
            addCriterion("PREVALIDITY =", value, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityNotEqualTo(Short value) {
            addCriterion("PREVALIDITY <>", value, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityGreaterThan(Short value) {
            addCriterion("PREVALIDITY >", value, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityGreaterThanOrEqualTo(Short value) {
            addCriterion("PREVALIDITY >=", value, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityLessThan(Short value) {
            addCriterion("PREVALIDITY <", value, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityLessThanOrEqualTo(Short value) {
            addCriterion("PREVALIDITY <=", value, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityIn(List<Short> values) {
            addCriterion("PREVALIDITY in", values, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityNotIn(List<Short> values) {
            addCriterion("PREVALIDITY not in", values, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityBetween(Short value1, Short value2) {
            addCriterion("PREVALIDITY between", value1, value2, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPrevalidityNotBetween(Short value1, Short value2) {
            addCriterion("PREVALIDITY not between", value1, value2, "prevalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityIsNull() {
            addCriterion("POSTVALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andPostvalidityIsNotNull() {
            addCriterion("POSTVALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andPostvalidityEqualTo(Short value) {
            addCriterion("POSTVALIDITY =", value, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityNotEqualTo(Short value) {
            addCriterion("POSTVALIDITY <>", value, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityGreaterThan(Short value) {
            addCriterion("POSTVALIDITY >", value, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityGreaterThanOrEqualTo(Short value) {
            addCriterion("POSTVALIDITY >=", value, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityLessThan(Short value) {
            addCriterion("POSTVALIDITY <", value, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityLessThanOrEqualTo(Short value) {
            addCriterion("POSTVALIDITY <=", value, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityIn(List<Short> values) {
            addCriterion("POSTVALIDITY in", values, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityNotIn(List<Short> values) {
            addCriterion("POSTVALIDITY not in", values, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityBetween(Short value1, Short value2) {
            addCriterion("POSTVALIDITY between", value1, value2, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostvalidityNotBetween(Short value1, Short value2) {
            addCriterion("POSTVALIDITY not between", value1, value2, "postvalidity");
            return (Criteria) this;
        }

        public Criteria andPostfrdtIsNull() {
            addCriterion("POSTFRDT is null");
            return (Criteria) this;
        }

        public Criteria andPostfrdtIsNotNull() {
            addCriterion("POSTFRDT is not null");
            return (Criteria) this;
        }

        public Criteria andPostfrdtEqualTo(String value) {
            addCriterion("POSTFRDT =", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtNotEqualTo(String value) {
            addCriterion("POSTFRDT <>", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtGreaterThan(String value) {
            addCriterion("POSTFRDT >", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtGreaterThanOrEqualTo(String value) {
            addCriterion("POSTFRDT >=", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtLessThan(String value) {
            addCriterion("POSTFRDT <", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtLessThanOrEqualTo(String value) {
            addCriterion("POSTFRDT <=", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtLike(String value) {
            addCriterion("POSTFRDT like", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtNotLike(String value) {
            addCriterion("POSTFRDT not like", value, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtIn(List<String> values) {
            addCriterion("POSTFRDT in", values, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtNotIn(List<String> values) {
            addCriterion("POSTFRDT not in", values, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtBetween(String value1, String value2) {
            addCriterion("POSTFRDT between", value1, value2, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPostfrdtNotBetween(String value1, String value2) {
            addCriterion("POSTFRDT not between", value1, value2, "postfrdt");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityIsNull() {
            addCriterion("PREAUTH_VALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityIsNotNull() {
            addCriterion("PREAUTH_VALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityEqualTo(Short value) {
            addCriterion("PREAUTH_VALIDITY =", value, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityNotEqualTo(Short value) {
            addCriterion("PREAUTH_VALIDITY <>", value, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityGreaterThan(Short value) {
            addCriterion("PREAUTH_VALIDITY >", value, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityGreaterThanOrEqualTo(Short value) {
            addCriterion("PREAUTH_VALIDITY >=", value, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityLessThan(Short value) {
            addCriterion("PREAUTH_VALIDITY <", value, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityLessThanOrEqualTo(Short value) {
            addCriterion("PREAUTH_VALIDITY <=", value, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityIn(List<Short> values) {
            addCriterion("PREAUTH_VALIDITY in", values, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityNotIn(List<Short> values) {
            addCriterion("PREAUTH_VALIDITY not in", values, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityBetween(Short value1, Short value2) {
            addCriterion("PREAUTH_VALIDITY between", value1, value2, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthValidityNotBetween(Short value1, Short value2) {
            addCriterion("PREAUTH_VALIDITY not between", value1, value2, "preauthValidity");
            return (Criteria) this;
        }

        public Criteria andLoaNoteIsNull() {
            addCriterion("LOA_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andLoaNoteIsNotNull() {
            addCriterion("LOA_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andLoaNoteEqualTo(Object value) {
            addCriterion("LOA_NOTE =", value, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteNotEqualTo(Object value) {
            addCriterion("LOA_NOTE <>", value, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteGreaterThan(Object value) {
            addCriterion("LOA_NOTE >", value, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteGreaterThanOrEqualTo(Object value) {
            addCriterion("LOA_NOTE >=", value, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteLessThan(Object value) {
            addCriterion("LOA_NOTE <", value, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteLessThanOrEqualTo(Object value) {
            addCriterion("LOA_NOTE <=", value, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteIn(List<Object> values) {
            addCriterion("LOA_NOTE in", values, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteNotIn(List<Object> values) {
            addCriterion("LOA_NOTE not in", values, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteBetween(Object value1, Object value2) {
            addCriterion("LOA_NOTE between", value1, value2, "loaNote");
            return (Criteria) this;
        }

        public Criteria andLoaNoteNotBetween(Object value1, Object value2) {
            addCriterion("LOA_NOTE not between", value1, value2, "loaNote");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodIsNull() {
            addCriterion("WAITING_PERIOD is null");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodIsNotNull() {
            addCriterion("WAITING_PERIOD is not null");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodEqualTo(Short value) {
            addCriterion("WAITING_PERIOD =", value, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodNotEqualTo(Short value) {
            addCriterion("WAITING_PERIOD <>", value, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodGreaterThan(Short value) {
            addCriterion("WAITING_PERIOD >", value, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodGreaterThanOrEqualTo(Short value) {
            addCriterion("WAITING_PERIOD >=", value, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodLessThan(Short value) {
            addCriterion("WAITING_PERIOD <", value, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodLessThanOrEqualTo(Short value) {
            addCriterion("WAITING_PERIOD <=", value, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodIn(List<Short> values) {
            addCriterion("WAITING_PERIOD in", values, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodNotIn(List<Short> values) {
            addCriterion("WAITING_PERIOD not in", values, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodBetween(Short value1, Short value2) {
            addCriterion("WAITING_PERIOD between", value1, value2, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andWaitingPeriodNotBetween(Short value1, Short value2) {
            addCriterion("WAITING_PERIOD not between", value1, value2, "waitingPeriod");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledIsNull() {
            addCriterion("MEMBER_ENTITLED is null");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledIsNotNull() {
            addCriterion("MEMBER_ENTITLED is not null");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledEqualTo(String value) {
            addCriterion("MEMBER_ENTITLED =", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledNotEqualTo(String value) {
            addCriterion("MEMBER_ENTITLED <>", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledGreaterThan(String value) {
            addCriterion("MEMBER_ENTITLED >", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_ENTITLED >=", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledLessThan(String value) {
            addCriterion("MEMBER_ENTITLED <", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_ENTITLED <=", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledLike(String value) {
            addCriterion("MEMBER_ENTITLED like", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledNotLike(String value) {
            addCriterion("MEMBER_ENTITLED not like", value, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledIn(List<String> values) {
            addCriterion("MEMBER_ENTITLED in", values, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledNotIn(List<String> values) {
            addCriterion("MEMBER_ENTITLED not in", values, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledBetween(String value1, String value2) {
            addCriterion("MEMBER_ENTITLED between", value1, value2, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andMemberEntitledNotBetween(String value1, String value2) {
            addCriterion("MEMBER_ENTITLED not between", value1, value2, "memberEntitled");
            return (Criteria) this;
        }

        public Criteria andAccopValidityIsNull() {
            addCriterion("ACCOP_VALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andAccopValidityIsNotNull() {
            addCriterion("ACCOP_VALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andAccopValidityEqualTo(Short value) {
            addCriterion("ACCOP_VALIDITY =", value, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityNotEqualTo(Short value) {
            addCriterion("ACCOP_VALIDITY <>", value, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityGreaterThan(Short value) {
            addCriterion("ACCOP_VALIDITY >", value, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityGreaterThanOrEqualTo(Short value) {
            addCriterion("ACCOP_VALIDITY >=", value, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityLessThan(Short value) {
            addCriterion("ACCOP_VALIDITY <", value, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityLessThanOrEqualTo(Short value) {
            addCriterion("ACCOP_VALIDITY <=", value, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityIn(List<Short> values) {
            addCriterion("ACCOP_VALIDITY in", values, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityNotIn(List<Short> values) {
            addCriterion("ACCOP_VALIDITY not in", values, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityBetween(Short value1, Short value2) {
            addCriterion("ACCOP_VALIDITY between", value1, value2, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andAccopValidityNotBetween(Short value1, Short value2) {
            addCriterion("ACCOP_VALIDITY not between", value1, value2, "accopValidity");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNull() {
            addCriterion("START_DATE is null");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNotNull() {
            addCriterion("START_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andStartDateEqualTo(Date value) {
            addCriterion("START_DATE =", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotEqualTo(Date value) {
            addCriterion("START_DATE <>", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThan(Date value) {
            addCriterion("START_DATE >", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThanOrEqualTo(Date value) {
            addCriterion("START_DATE >=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThan(Date value) {
            addCriterion("START_DATE <", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThanOrEqualTo(Date value) {
            addCriterion("START_DATE <=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIn(List<Date> values) {
            addCriterion("START_DATE in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotIn(List<Date> values) {
            addCriterion("START_DATE not in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateBetween(Date value1, Date value2) {
            addCriterion("START_DATE between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotBetween(Date value1, Date value2) {
            addCriterion("START_DATE not between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNull() {
            addCriterion("END_DATE is null");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNotNull() {
            addCriterion("END_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andEndDateEqualTo(Date value) {
            addCriterion("END_DATE =", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotEqualTo(Date value) {
            addCriterion("END_DATE <>", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThan(Date value) {
            addCriterion("END_DATE >", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThanOrEqualTo(Date value) {
            addCriterion("END_DATE >=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThan(Date value) {
            addCriterion("END_DATE <", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThanOrEqualTo(Date value) {
            addCriterion("END_DATE <=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIn(List<Date> values) {
            addCriterion("END_DATE in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotIn(List<Date> values) {
            addCriterion("END_DATE not in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateBetween(Date value1, Date value2) {
            addCriterion("END_DATE between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotBetween(Date value1, Date value2) {
            addCriterion("END_DATE not between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andPostcashlessIsNull() {
            addCriterion("POSTCASHLESS is null");
            return (Criteria) this;
        }

        public Criteria andPostcashlessIsNotNull() {
            addCriterion("POSTCASHLESS is not null");
            return (Criteria) this;
        }

        public Criteria andPostcashlessEqualTo(String value) {
            addCriterion("POSTCASHLESS =", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessNotEqualTo(String value) {
            addCriterion("POSTCASHLESS <>", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessGreaterThan(String value) {
            addCriterion("POSTCASHLESS >", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessGreaterThanOrEqualTo(String value) {
            addCriterion("POSTCASHLESS >=", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessLessThan(String value) {
            addCriterion("POSTCASHLESS <", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessLessThanOrEqualTo(String value) {
            addCriterion("POSTCASHLESS <=", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessLike(String value) {
            addCriterion("POSTCASHLESS like", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessNotLike(String value) {
            addCriterion("POSTCASHLESS not like", value, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessIn(List<String> values) {
            addCriterion("POSTCASHLESS in", values, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessNotIn(List<String> values) {
            addCriterion("POSTCASHLESS not in", values, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessBetween(String value1, String value2) {
            addCriterion("POSTCASHLESS between", value1, value2, "postcashless");
            return (Criteria) this;
        }

        public Criteria andPostcashlessNotBetween(String value1, String value2) {
            addCriterion("POSTCASHLESS not between", value1, value2, "postcashless");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateIsNull() {
            addCriterion("CONDITION_BASE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateIsNotNull() {
            addCriterion("CONDITION_BASE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateEqualTo(String value) {
            addCriterion("CONDITION_BASE_DATE =", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateNotEqualTo(String value) {
            addCriterion("CONDITION_BASE_DATE <>", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateGreaterThan(String value) {
            addCriterion("CONDITION_BASE_DATE >", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateGreaterThanOrEqualTo(String value) {
            addCriterion("CONDITION_BASE_DATE >=", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateLessThan(String value) {
            addCriterion("CONDITION_BASE_DATE <", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateLessThanOrEqualTo(String value) {
            addCriterion("CONDITION_BASE_DATE <=", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateLike(String value) {
            addCriterion("CONDITION_BASE_DATE like", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateNotLike(String value) {
            addCriterion("CONDITION_BASE_DATE not like", value, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateIn(List<String> values) {
            addCriterion("CONDITION_BASE_DATE in", values, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateNotIn(List<String> values) {
            addCriterion("CONDITION_BASE_DATE not in", values, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateBetween(String value1, String value2) {
            addCriterion("CONDITION_BASE_DATE between", value1, value2, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andConditionBaseDateNotBetween(String value1, String value2) {
            addCriterion("CONDITION_BASE_DATE not between", value1, value2, "conditionBaseDate");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("REMARKS =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("REMARKS <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("REMARKS >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("REMARKS >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("REMARKS <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("REMARKS <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("REMARKS like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("REMARKS not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("REMARKS in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("REMARKS not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("REMARKS between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("REMARKS not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityIsNull() {
            addCriterion("ACCOP_POSTVALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityIsNotNull() {
            addCriterion("ACCOP_POSTVALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityEqualTo(Short value) {
            addCriterion("ACCOP_POSTVALIDITY =", value, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityNotEqualTo(Short value) {
            addCriterion("ACCOP_POSTVALIDITY <>", value, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityGreaterThan(Short value) {
            addCriterion("ACCOP_POSTVALIDITY >", value, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityGreaterThanOrEqualTo(Short value) {
            addCriterion("ACCOP_POSTVALIDITY >=", value, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityLessThan(Short value) {
            addCriterion("ACCOP_POSTVALIDITY <", value, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityLessThanOrEqualTo(Short value) {
            addCriterion("ACCOP_POSTVALIDITY <=", value, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityIn(List<Short> values) {
            addCriterion("ACCOP_POSTVALIDITY in", values, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityNotIn(List<Short> values) {
            addCriterion("ACCOP_POSTVALIDITY not in", values, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityBetween(Short value1, Short value2) {
            addCriterion("ACCOP_POSTVALIDITY between", value1, value2, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andAccopPostvalidityNotBetween(Short value1, Short value2) {
            addCriterion("ACCOP_POSTVALIDITY not between", value1, value2, "accopPostvalidity");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredIsNull() {
            addCriterion("PREAUTH_REQUIRED is null");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredIsNotNull() {
            addCriterion("PREAUTH_REQUIRED is not null");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredEqualTo(String value) {
            addCriterion("PREAUTH_REQUIRED =", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredNotEqualTo(String value) {
            addCriterion("PREAUTH_REQUIRED <>", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredGreaterThan(String value) {
            addCriterion("PREAUTH_REQUIRED >", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredGreaterThanOrEqualTo(String value) {
            addCriterion("PREAUTH_REQUIRED >=", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredLessThan(String value) {
            addCriterion("PREAUTH_REQUIRED <", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredLessThanOrEqualTo(String value) {
            addCriterion("PREAUTH_REQUIRED <=", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredLike(String value) {
            addCriterion("PREAUTH_REQUIRED like", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredNotLike(String value) {
            addCriterion("PREAUTH_REQUIRED not like", value, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredIn(List<String> values) {
            addCriterion("PREAUTH_REQUIRED in", values, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredNotIn(List<String> values) {
            addCriterion("PREAUTH_REQUIRED not in", values, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredBetween(String value1, String value2) {
            addCriterion("PREAUTH_REQUIRED between", value1, value2, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredNotBetween(String value1, String value2) {
            addCriterion("PREAUTH_REQUIRED not between", value1, value2, "preauthRequired");
            return (Criteria) this;
        }

        public Criteria andMobileNoteIsNull() {
            addCriterion("MOBILE_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andMobileNoteIsNotNull() {
            addCriterion("MOBILE_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andMobileNoteEqualTo(String value) {
            addCriterion("MOBILE_NOTE =", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteNotEqualTo(String value) {
            addCriterion("MOBILE_NOTE <>", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteGreaterThan(String value) {
            addCriterion("MOBILE_NOTE >", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE_NOTE >=", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteLessThan(String value) {
            addCriterion("MOBILE_NOTE <", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteLessThanOrEqualTo(String value) {
            addCriterion("MOBILE_NOTE <=", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteLike(String value) {
            addCriterion("MOBILE_NOTE like", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteNotLike(String value) {
            addCriterion("MOBILE_NOTE not like", value, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteIn(List<String> values) {
            addCriterion("MOBILE_NOTE in", values, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteNotIn(List<String> values) {
            addCriterion("MOBILE_NOTE not in", values, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteBetween(String value1, String value2) {
            addCriterion("MOBILE_NOTE between", value1, value2, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileNoteNotBetween(String value1, String value2) {
            addCriterion("MOBILE_NOTE not between", value1, value2, "mobileNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteIsNull() {
            addCriterion("MOBILE_ENGLISH_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteIsNotNull() {
            addCriterion("MOBILE_ENGLISH_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteEqualTo(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE =", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteNotEqualTo(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE <>", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteGreaterThan(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE >", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE >=", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteLessThan(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE <", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteLessThanOrEqualTo(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE <=", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteLike(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE like", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteNotLike(String value) {
            addCriterion("MOBILE_ENGLISH_NOTE not like", value, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteIn(List<String> values) {
            addCriterion("MOBILE_ENGLISH_NOTE in", values, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteNotIn(List<String> values) {
            addCriterion("MOBILE_ENGLISH_NOTE not in", values, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteBetween(String value1, String value2) {
            addCriterion("MOBILE_ENGLISH_NOTE between", value1, value2, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andMobileEnglishNoteNotBetween(String value1, String value2) {
            addCriterion("MOBILE_ENGLISH_NOTE not between", value1, value2, "mobileEnglishNote");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueIsNull() {
            addCriterion("EDCMAX_VALUE is null");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueIsNotNull() {
            addCriterion("EDCMAX_VALUE is not null");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueEqualTo(BigDecimal value) {
            addCriterion("EDCMAX_VALUE =", value, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueNotEqualTo(BigDecimal value) {
            addCriterion("EDCMAX_VALUE <>", value, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueGreaterThan(BigDecimal value) {
            addCriterion("EDCMAX_VALUE >", value, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("EDCMAX_VALUE >=", value, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueLessThan(BigDecimal value) {
            addCriterion("EDCMAX_VALUE <", value, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("EDCMAX_VALUE <=", value, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueIn(List<BigDecimal> values) {
            addCriterion("EDCMAX_VALUE in", values, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueNotIn(List<BigDecimal> values) {
            addCriterion("EDCMAX_VALUE not in", values, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("EDCMAX_VALUE between", value1, value2, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andEdcmaxValueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("EDCMAX_VALUE not between", value1, value2, "edcmaxValue");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityIsNull() {
            addCriterion("CASHLESS_FACILITY is null");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityIsNotNull() {
            addCriterion("CASHLESS_FACILITY is not null");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityEqualTo(String value) {
            addCriterion("CASHLESS_FACILITY =", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityNotEqualTo(String value) {
            addCriterion("CASHLESS_FACILITY <>", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityGreaterThan(String value) {
            addCriterion("CASHLESS_FACILITY >", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityGreaterThanOrEqualTo(String value) {
            addCriterion("CASHLESS_FACILITY >=", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityLessThan(String value) {
            addCriterion("CASHLESS_FACILITY <", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityLessThanOrEqualTo(String value) {
            addCriterion("CASHLESS_FACILITY <=", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityLike(String value) {
            addCriterion("CASHLESS_FACILITY like", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityNotLike(String value) {
            addCriterion("CASHLESS_FACILITY not like", value, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityIn(List<String> values) {
            addCriterion("CASHLESS_FACILITY in", values, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityNotIn(List<String> values) {
            addCriterion("CASHLESS_FACILITY not in", values, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityBetween(String value1, String value2) {
            addCriterion("CASHLESS_FACILITY between", value1, value2, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andCashlessFacilityNotBetween(String value1, String value2) {
            addCriterion("CASHLESS_FACILITY not between", value1, value2, "cashlessFacility");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyIsNull() {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY is null");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyIsNotNull() {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY is not null");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyEqualTo(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY =", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyNotEqualTo(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY <>", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyGreaterThan(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY >", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyGreaterThanOrEqualTo(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY >=", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyLessThan(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY <", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyLessThanOrEqualTo(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY <=", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyLike(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY like", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyNotLike(String value) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY not like", value, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyIn(List<String> values) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY in", values, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyNotIn(List<String> values) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY not in", values, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyBetween(String value1, String value2) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY between", value1, value2, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andVisitRestrictedProviderOnlyNotBetween(String value1, String value2) {
            addCriterion("VISIT_RESTRICTED_PROVIDER_ONLY not between", value1, value2, "visitRestrictedProviderOnly");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityIsNull() {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityIsNotNull() {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityEqualTo(Short value) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY =", value, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityNotEqualTo(Short value) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY <>", value, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityGreaterThan(Short value) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY >", value, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityGreaterThanOrEqualTo(Short value) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY >=", value, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityLessThan(Short value) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY <", value, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityLessThanOrEqualTo(Short value) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY <=", value, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityIn(List<Short> values) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY in", values, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityNotIn(List<Short> values) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY not in", values, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityBetween(Short value1, Short value2) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY between", value1, value2, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andClaimsSubmissionValidityNotBetween(Short value1, Short value2) {
            addCriterion("CLAIMS_SUBMISSION_VALIDITY not between", value1, value2, "claimsSubmissionValidity");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredIsNull() {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED is null");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredIsNotNull() {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED is not null");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredEqualTo(BigDecimal value) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED =", value, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredNotEqualTo(BigDecimal value) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED <>", value, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredGreaterThan(BigDecimal value) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED >", value, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED >=", value, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredLessThan(BigDecimal value) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED <", value, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED <=", value, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredIn(List<BigDecimal> values) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED in", values, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredNotIn(List<BigDecimal> values) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED not in", values, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED between", value1, value2, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andPreauthRequiredAmtIncurredNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PREAUTH_REQUIRED_AMT_INCURRED not between", value1, value2, "preauthRequiredAmtIncurred");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeIsNull() {
            addCriterion("REFERRAL_NETWORK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeIsNotNull() {
            addCriterion("REFERRAL_NETWORK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeEqualTo(String value) {
            addCriterion("REFERRAL_NETWORK_CODE =", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeNotEqualTo(String value) {
            addCriterion("REFERRAL_NETWORK_CODE <>", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeGreaterThan(String value) {
            addCriterion("REFERRAL_NETWORK_CODE >", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_NETWORK_CODE >=", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeLessThan(String value) {
            addCriterion("REFERRAL_NETWORK_CODE <", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_NETWORK_CODE <=", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeLike(String value) {
            addCriterion("REFERRAL_NETWORK_CODE like", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeNotLike(String value) {
            addCriterion("REFERRAL_NETWORK_CODE not like", value, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeIn(List<String> values) {
            addCriterion("REFERRAL_NETWORK_CODE in", values, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeNotIn(List<String> values) {
            addCriterion("REFERRAL_NETWORK_CODE not in", values, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeBetween(String value1, String value2) {
            addCriterion("REFERRAL_NETWORK_CODE between", value1, value2, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andReferralNetworkCodeNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_NETWORK_CODE not between", value1, value2, "referralNetworkCode");
            return (Criteria) this;
        }

        public Criteria andInsertByIsNull() {
            addCriterion("INSERT_BY is null");
            return (Criteria) this;
        }

        public Criteria andInsertByIsNotNull() {
            addCriterion("INSERT_BY is not null");
            return (Criteria) this;
        }

        public Criteria andInsertByEqualTo(String value) {
            addCriterion("INSERT_BY =", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotEqualTo(String value) {
            addCriterion("INSERT_BY <>", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByGreaterThan(String value) {
            addCriterion("INSERT_BY >", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_BY >=", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLessThan(String value) {
            addCriterion("INSERT_BY <", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLessThanOrEqualTo(String value) {
            addCriterion("INSERT_BY <=", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLike(String value) {
            addCriterion("INSERT_BY like", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotLike(String value) {
            addCriterion("INSERT_BY not like", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByIn(List<String> values) {
            addCriterion("INSERT_BY in", values, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotIn(List<String> values) {
            addCriterion("INSERT_BY not in", values, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByBetween(String value1, String value2) {
            addCriterion("INSERT_BY between", value1, value2, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotBetween(String value1, String value2) {
            addCriterion("INSERT_BY not between", value1, value2, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNull() {
            addCriterion("INSERT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNotNull() {
            addCriterion("INSERT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInsertDateEqualTo(Date value) {
            addCriterion("INSERT_DATE =", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotEqualTo(Date value) {
            addCriterion("INSERT_DATE <>", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThan(Date value) {
            addCriterion("INSERT_DATE >", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThanOrEqualTo(Date value) {
            addCriterion("INSERT_DATE >=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThan(Date value) {
            addCriterion("INSERT_DATE <", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThanOrEqualTo(Date value) {
            addCriterion("INSERT_DATE <=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateIn(List<Date> values) {
            addCriterion("INSERT_DATE in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotIn(List<Date> values) {
            addCriterion("INSERT_DATE not in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateBetween(Date value1, Date value2) {
            addCriterion("INSERT_DATE between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotBetween(Date value1, Date value2) {
            addCriterion("INSERT_DATE not between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseIsNull() {
            addCriterion("PREAUTH_MAXUSE is null");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseIsNotNull() {
            addCriterion("PREAUTH_MAXUSE is not null");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseEqualTo(Short value) {
            addCriterion("PREAUTH_MAXUSE =", value, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseNotEqualTo(Short value) {
            addCriterion("PREAUTH_MAXUSE <>", value, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseGreaterThan(Short value) {
            addCriterion("PREAUTH_MAXUSE >", value, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseGreaterThanOrEqualTo(Short value) {
            addCriterion("PREAUTH_MAXUSE >=", value, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseLessThan(Short value) {
            addCriterion("PREAUTH_MAXUSE <", value, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseLessThanOrEqualTo(Short value) {
            addCriterion("PREAUTH_MAXUSE <=", value, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseIn(List<Short> values) {
            addCriterion("PREAUTH_MAXUSE in", values, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseNotIn(List<Short> values) {
            addCriterion("PREAUTH_MAXUSE not in", values, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseBetween(Short value1, Short value2) {
            addCriterion("PREAUTH_MAXUSE between", value1, value2, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andPreauthMaxuseNotBetween(Short value1, Short value2) {
            addCriterion("PREAUTH_MAXUSE not between", value1, value2, "preauthMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredIsNull() {
            addCriterion("REFERRAL_REQUIRED is null");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredIsNotNull() {
            addCriterion("REFERRAL_REQUIRED is not null");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredEqualTo(String value) {
            addCriterion("REFERRAL_REQUIRED =", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredNotEqualTo(String value) {
            addCriterion("REFERRAL_REQUIRED <>", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredGreaterThan(String value) {
            addCriterion("REFERRAL_REQUIRED >", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_REQUIRED >=", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredLessThan(String value) {
            addCriterion("REFERRAL_REQUIRED <", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_REQUIRED <=", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredLike(String value) {
            addCriterion("REFERRAL_REQUIRED like", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredNotLike(String value) {
            addCriterion("REFERRAL_REQUIRED not like", value, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredIn(List<String> values) {
            addCriterion("REFERRAL_REQUIRED in", values, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredNotIn(List<String> values) {
            addCriterion("REFERRAL_REQUIRED not in", values, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredBetween(String value1, String value2) {
            addCriterion("REFERRAL_REQUIRED between", value1, value2, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralRequiredNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_REQUIRED not between", value1, value2, "referralRequired");
            return (Criteria) this;
        }

        public Criteria andReferralValidityIsNull() {
            addCriterion("REFERRAL_VALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andReferralValidityIsNotNull() {
            addCriterion("REFERRAL_VALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andReferralValidityEqualTo(Short value) {
            addCriterion("REFERRAL_VALIDITY =", value, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityNotEqualTo(Short value) {
            addCriterion("REFERRAL_VALIDITY <>", value, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityGreaterThan(Short value) {
            addCriterion("REFERRAL_VALIDITY >", value, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityGreaterThanOrEqualTo(Short value) {
            addCriterion("REFERRAL_VALIDITY >=", value, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityLessThan(Short value) {
            addCriterion("REFERRAL_VALIDITY <", value, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityLessThanOrEqualTo(Short value) {
            addCriterion("REFERRAL_VALIDITY <=", value, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityIn(List<Short> values) {
            addCriterion("REFERRAL_VALIDITY in", values, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityNotIn(List<Short> values) {
            addCriterion("REFERRAL_VALIDITY not in", values, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityBetween(Short value1, Short value2) {
            addCriterion("REFERRAL_VALIDITY between", value1, value2, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralValidityNotBetween(Short value1, Short value2) {
            addCriterion("REFERRAL_VALIDITY not between", value1, value2, "referralValidity");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseIsNull() {
            addCriterion("REFERRAL_MAXUSE is null");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseIsNotNull() {
            addCriterion("REFERRAL_MAXUSE is not null");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseEqualTo(Short value) {
            addCriterion("REFERRAL_MAXUSE =", value, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseNotEqualTo(Short value) {
            addCriterion("REFERRAL_MAXUSE <>", value, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseGreaterThan(Short value) {
            addCriterion("REFERRAL_MAXUSE >", value, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseGreaterThanOrEqualTo(Short value) {
            addCriterion("REFERRAL_MAXUSE >=", value, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseLessThan(Short value) {
            addCriterion("REFERRAL_MAXUSE <", value, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseLessThanOrEqualTo(Short value) {
            addCriterion("REFERRAL_MAXUSE <=", value, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseIn(List<Short> values) {
            addCriterion("REFERRAL_MAXUSE in", values, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseNotIn(List<Short> values) {
            addCriterion("REFERRAL_MAXUSE not in", values, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseBetween(Short value1, Short value2) {
            addCriterion("REFERRAL_MAXUSE between", value1, value2, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReferralMaxuseNotBetween(Short value1, Short value2) {
            addCriterion("REFERRAL_MAXUSE not between", value1, value2, "referralMaxuse");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityIsNull() {
            addCriterion("REIMBURSE_FACILITY is null");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityIsNotNull() {
            addCriterion("REIMBURSE_FACILITY is not null");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityEqualTo(String value) {
            addCriterion("REIMBURSE_FACILITY =", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityNotEqualTo(String value) {
            addCriterion("REIMBURSE_FACILITY <>", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityGreaterThan(String value) {
            addCriterion("REIMBURSE_FACILITY >", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityGreaterThanOrEqualTo(String value) {
            addCriterion("REIMBURSE_FACILITY >=", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityLessThan(String value) {
            addCriterion("REIMBURSE_FACILITY <", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityLessThanOrEqualTo(String value) {
            addCriterion("REIMBURSE_FACILITY <=", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityLike(String value) {
            addCriterion("REIMBURSE_FACILITY like", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityNotLike(String value) {
            addCriterion("REIMBURSE_FACILITY not like", value, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityIn(List<String> values) {
            addCriterion("REIMBURSE_FACILITY in", values, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityNotIn(List<String> values) {
            addCriterion("REIMBURSE_FACILITY not in", values, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityBetween(String value1, String value2) {
            addCriterion("REIMBURSE_FACILITY between", value1, value2, "reimburseFacility");
            return (Criteria) this;
        }

        public Criteria andReimburseFacilityNotBetween(String value1, String value2) {
            addCriterion("REIMBURSE_FACILITY not between", value1, value2, "reimburseFacility");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}